The results from the modeling node might show Run Status messages such as:

Error: Could not open EMWS.Trans_TRAIN.

Error: exception.server.SCLException.INVALIDARGUMENT,DMDBCAT,
  invalid DMDB Catalog

Error: exception.server.EM.RUNTIMEERROR,3000

When creating the transformed variable, SAS Enterprise Miner creates a new label incorporating the label text from the source variable. When the source variable label contains a single quote (for example, "Client's Debt Income"), the transformed variable label will have mismatched quotes in the generated SAS code. This causes the successor node to fail.

The following is an example of the transformation code generated by the Transform Variables node. The label assigned is "Transformed: Client" and the remainder of the text generates invalid syntax for the Label statement.

*------------------------------------------------------------*;
* TRANSFORM: DEBTINC , log(DEBTINC + 1);
*------------------------------------------------------------*;
label LOG_DEBTINC = 'Transformed: Client's Debt Income';
if DEBTINC + 1 > 0 then LOG_DEBTINC = log(DEBTINC + 1);
else LOG_DEBTINC = .;

To circumvent to the problem, modify your source data in one of the following ways:

1. Remove the single quote from the source variable's label. In the above example, the label for DEBTINC might be: Client Debt Income.
2. Use two single quotes in the label rather than one single quote. For example: Client''s Debt Income

Some examples of modeling nodes: AutoNeural, Decision Tree, Dmine Regression, DMNeural, Ensemble, MBR, Neural Network, Regression, Rule Induction, TwoStage

Operating System and Release Information